SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 644401 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 644401 [ RunTime:0.001764s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (105457,594626,923445,604924,1033915,204195,269784,483590,712139,144812,506548,641787,451786,485163,260056,457495,47585,971859,618359,705442,753830,134894,553784,152908,172993,552026,478996,498165,406753,482435,170070,1041949,741841,919694,161161,264096,823419,419015,609676,901481,404249,849618,937591,320623,678747,711749,621429,73414,694191,755932,500425,356048,238720,813162,975179,1036082,763354,364458,381536,544988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 644401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 644401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]