SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414423 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414423 [ RunTime:0.001773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (835351,238406,380443,1004697,558346,265065,388845,192585,546922,1043718,680932,576433,201273,695287,707352,702073,210180,741784,430490,688569,242929,978812,1013793,1015026,90927,197628,711629,211187,418015,896458,29444,173481,812758,594592,375133,452837,987879,59536,281393,644516,1037830,299268,427431,923281,97532,782314,298029,499770,39453,855823,187271,122279,953991,836164,383542,1034546,15273,815380,916846,730418) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000406s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]