SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 345908 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 345908 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712013,102542,47953,661945,1012215,658066,694924,801478,663909,894972,698596,562880,261211,707464,942844,301367,290149,116725,432937,899457,250085,872090,320342,995970,1047258,154501,422206,294943,352444,30136,710405,698081,366964,574883,1012500,525660,809420,661864,642868,988033,144390,565180,478746,57348,666441,390956,21901,722929,1046814,797089,800410,779372,876068,321843,862288,327817,320845,231249,602463,982547) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 345908 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 345908 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000449s ]