SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002002s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 417964 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 417964 [ RunTime:0.004101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839102,774423,148218,910848,5522,478551,757393,256854,286341,194184,910874,531237,733198,549545,739292,1048433,408315,140637,357899,86625,415850,336370,861269,950652,496268,337068,761817,463104,902368,360119,546504,875722,645922,871987,962954,103464,277730,223142,819336,601569,219389,151056,382309,953729,384347,267468,501625,14372,242751,954463,99775,783984,706497,889057,248295,364327,734838,820191,300230,927874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 417964 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000521s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 417964 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]