SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001014s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401504 LIMIT 1 [ RunTime:0.000969s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401504 [ RunTime:0.002989s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174114,407074,658543,1490,5433,373088,723563,184406,744502,24034,78673,770230,333370,836608,544619,406252,316050,367625,109020,851802,845873,507827,152484,429350,1512,948044,697656,421104,955838,737015,509608,249747,30800,945605,675707,243574,165970,350341,59148,652883,523281,902287,354079,534108,950283,150635,544958,441350,790207,346336,69533,640530,720423,683560,124815,612252,111103,666927,908995,717226) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000966s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]