SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504552 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504552 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (480352,139565,348798,21712,451956,570743,501669,720888,196732,230448,295145,142966,114100,301061,171306,850126,19962,896163,802450,152973,297693,946749,544380,687010,789125,1032285,598206,457920,808415,239223,880531,34893,829657,588259,474251,727353,794285,445004,665385,972437,1027937,480420,329438,825860,378894,998668,918032,785766,246262,755539,33179,294271,39032,516540,279061,817345,901115,545518,397846,242092) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504552 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504552 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000625s ]