SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 785291 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 785291 [ RunTime:0.002148s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (540783,708792,656148,745628,797673,785764,182819,59636,1003264,643442,1041992,737216,154075,432433,239159,221766,495020,86076,105844,913482,57682,323137,138996,705933,629877,177257,457806,277969,568725,625426,898167,541077,182414,454181,321080,884420,72968,800176,613827,599583,501816,1025465,472110,950657,342308,801471,222692,673889,809182,670757,892628,839871,976322,1023499,925522,409738,956790,40350,277073,536952) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 785291 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 785291 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]