SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410830 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410830 [ RunTime:0.003039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (350340,232745,314793,302685,532860,386945,203272,145626,197808,364364,331966,26440,335364,750306,868094,536836,41011,666036,411249,335639,645770,777145,242525,916513,1019172,106580,651961,15291,667824,995868,741180,563263,708576,349596,491327,610897,674701,572105,323174,242223,474812,174138,339548,718997,938485,385948,252077,221351,1005150,895508,723391,46206,263019,759509,917525,301014,414682,247927,59963,406206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]