SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001636s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521417 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521417 [ RunTime:0.001893s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585452,162552,875281,659967,58574,1024967,101405,1042358,252588,930311,537550,1031849,759359,514316,85894,613822,374546,846135,1007279,75986,50817,128356,860523,1043591,545361,390691,740382,955155,781107,889005,389699,55308,8480,465113,213377,990874,169986,7384,372552,157265,1004961,102290,516527,1016497,465832,594845,66584,104128,549017,142823,279668,500205,203749,307371,58511,649598,138195,297297,619051,588915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521417 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521417 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000914s ]