SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543011 LIMIT 1 [ RunTime:0.000439s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543011 [ RunTime:0.003026s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535896,13872,124189,303476,352572,973619,814476,303570,350238,965370,1009833,416058,342799,995808,894508,660621,1010144,566076,602086,427441,785649,506496,868070,245156,488648,772978,709945,452365,695244,703445,492916,973256,63648,44841,726735,970874,524724,329450,377266,18933,286215,754453,1039522,116103,422514,264215,641197,774948,638748,179173,128651,463322,514265,145353,814883,280219,1032194,844706,525048,462685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]