SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284687 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284687 [ RunTime:0.001769s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (964424,112817,348618,560160,108274,375444,809620,477149,914808,565737,302343,931922,978385,359756,1028023,59596,642479,506779,454317,821043,170640,242118,295801,31528,1041765,405401,1044141,309732,161970,331044,633159,1010253,101949,676172,359470,32341,784990,530217,519067,138440,551141,864811,138938,881727,992079,202157,898185,146399,797338,629749,839022,460788,115002,513848,350528,106536,513498,224103,993584,1023007) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284687 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284687 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000480s ]