SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506945 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506945 [ RunTime:0.003242s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (432052,563427,821278,836495,685638,348138,748963,249468,1015042,959680,500721,43219,261345,634352,133868,873624,22175,36104,810084,998973,174089,374337,768527,356629,761988,1020137,883273,1037209,186011,328617,240068,1034693,251302,442921,619499,167626,63139,22352,855757,481250,469502,350357,803072,462313,343389,16471,561738,572149,792757,1031386,34908,235226,286491,1048897,583065,486883,303241,435831,199664,371094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506945 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506945 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]