SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039483 LIMIT 1 [ RunTime:0.003919s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039483 [ RunTime:0.003550s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (25860,363051,284430,1034125,304853,1029469,687324,817971,574773,771903,830252,198735,224923,350808,215636,550374,164365,171816,544016,168608,734270,105515,821268,410897,727894,170373,462308,85961,84274,918481,634664,232528,174039,53463,114994,685859,518533,769206,876429,819891,912902,297700,486463,526443,498583,562238,76938,407938,893298,334936,1002665,105219,391462,198939,788968,697169,344968,23961,21295,99381) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]