SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199680 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199680 [ RunTime:0.001842s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547291,137404,41704,1017494,921449,563485,95372,305327,957858,926100,208822,584730,303921,776001,760307,640828,705784,208172,583837,334892,147339,500983,227948,216133,794838,251149,647954,972929,918215,200843,998452,523892,1024008,219899,464376,832374,138493,182499,75971,417311,144084,381571,576945,243353,832581,979553,13453,761985,773056,461003,976618,424646,129109,1045364,87795,922541,477765,57099,608312,452061) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.010129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199680 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199680 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000687s ]