SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445411 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445411 [ RunTime:0.001534s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554569,146596,332148,778047,621525,859941,12775,689047,88559,394635,40715,366397,319060,62671,299848,1046325,438507,1022725,113115,946267,246767,889527,441016,619759,72501,850291,159237,346997,686083,687611,89102,628492,715219,1035220,525756,881539,112393,954697,144081,1030247,10673,425807,548596,118313,399960,741670,814441,648132,713339,1046764,85346,555077,321702,1047536,1013867,414916,76812,951555,312325,327040) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]