SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411801 LIMIT 1 [ RunTime:0.000650s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411801 [ RunTime:0.003320s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037270,669088,648070,478315,75370,764483,711100,559008,574964,72311,35589,482272,53980,813551,199743,860717,386149,149843,842001,478420,744996,1042172,164690,86895,519541,365659,198174,341088,434425,493757,132382,308282,878943,603688,946424,272807,330399,228829,199568,812961,823150,680142,464733,998867,701874,23328,911798,793845,816121,466604,96418,243155,144555,247854,56271,1009237,395189,800242,726640,301577) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411801 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411801 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]