SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4458 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4458 [ RunTime:0.002477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926200,569566,331411,1008062,477868,1011815,850444,140253,978708,804905,675308,589922,537406,915919,544323,363786,49891,90822,661998,322492,489798,894372,596113,646729,464322,353191,524473,791843,707908,806345,482014,556272,93061,962001,666006,142797,609037,920964,933371,272597,387310,644397,441960,759999,620577,297378,489092,768370,560387,738636,329919,795431,695135,180440,961183,52691,671041,429480,620863,500168) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000681s ]