SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 583801 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 583801 [ RunTime:0.002110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034117,570449,702906,1018658,245407,1018072,1002460,498765,464903,679250,799005,953395,378990,541581,934866,221745,727866,841684,18405,924904,14973,324778,135814,951789,397116,344452,148690,845833,786246,699129,276257,228906,587200,130748,90877,305315,885197,766715,682871,531904,798552,64754,190529,809906,916575,914526,12462,1021427,888281,269925,433430,346012,508261,203495,879966,406585,725627,351144,10690,323020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 583801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 583801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]