SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 820411 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 820411 [ RunTime:0.002152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1002105,559246,365021,1025787,198659,660248,545369,386057,56406,813893,441156,724441,847573,758323,1027209,181196,810339,859980,288309,463429,717741,904551,528407,403050,231151,496702,102944,130388,894891,324463,616738,647226,942823,622526,1002391,86789,67231,899165,668534,571350,93403,317456,475815,434256,933400,717790,989504,773557,539627,559280,113644,402576,24394,994662,305400,486682,404000,252426,1012298,109562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000925s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 820411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 820411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]