SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 486733 LIMIT 1 [ RunTime:0.000464s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 486733 [ RunTime:0.003624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (551428,320973,814919,1012295,573989,288376,546725,888880,161543,884062,646697,105306,888384,225357,706481,675730,390079,398414,459375,794526,545244,976992,194077,532887,288628,791153,513429,1012511,86050,566069,842857,709234,163435,351343,117794,410763,755165,980853,273532,489552,703005,217000,735259,984688,553199,975633,404196,1089,848038,274533,498845,44190,614762,136990,56985,1024637,479368,581292,493434,489757) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001478s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 486733 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 486733 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002055s ]