SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320570 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320570 [ RunTime:0.001736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423118,82071,713683,400101,435926,80195,455395,928104,895551,954730,190261,412943,37554,821777,133440,399319,589822,638318,554228,50784,303610,198221,140877,423887,751307,902727,130841,10488,608139,612939,777159,218596,897004,251471,20913,721389,279532,316270,571071,931052,12369,301902,985033,138146,267010,83649,48358,144762,277781,757075,327184,679896,408609,872463,216103,322739,451906,1047630,427989,837044) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001942s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]