SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002524s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 846213 LIMIT 1 [ RunTime:0.001448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 846213 [ RunTime:0.003528s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011383,786393,543010,683042,687285,845490,404001,725038,846152,670183,288310,413227,709119,228033,693165,128935,1018617,74308,577399,132413,85805,641354,15692,875253,497780,882399,558439,111428,339516,929185,179548,136559,670991,90135,424797,900059,379632,338145,506021,856226,137886,564555,881605,74928,829716,910706,545200,969694,501652,543738,967978,971927,827239,293432,720964,5429,115203,689602,879884,666361) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 846213 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 846213 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001224s ]