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` = 48305 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48305 [ RunTime:0.003323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (833744,919581,825783,362613,140381,315252,900611,504456,350131,269410,479102,340646,66264,806904,794764,189101,985575,828029,236524,668204,813337,818448,259577,126330,763373,721370,1041476,220231,838272,209312,511278,133379,1004164,608994,675515,495030,111734,798220,617165,559720,132933,183702,118705,1015789,1008680,274127,84809,801712,44577,603266,965679,198807,765281,986875,818943,16678,340435,252946,348614,168184) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001246s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000517s ]