SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002837s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001224 LIMIT 1 [ RunTime:0.002255s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001224 [ RunTime:0.006747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (631160,112703,352056,82095,83872,350911,452697,502242,261495,1045266,835118,111079,901752,276665,930472,779502,895455,474837,274873,91359,789042,1011525,989673,425416,189470,1011628,85416,997869,1031782,470324,411151,202578,11595,532998,8262,200328,627474,970683,455496,898413,568401,433387,329479,868635,392712,641632,343182,673427,175333,998171,8487,828891,69059,160903,533599,708035,822613,269696,94229,682383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]