SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412149 LIMIT 1 [ RunTime:0.000625s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412149 [ RunTime:0.001577s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1034094,12902,188527,43892,390532,508354,913807,751719,926521,1037874,200656,423745,87338,239929,675372,829530,437312,879663,459828,172756,749,90644,697600,518180,245155,474055,654003,893537,869203,499792,93647,356385,410741,892472,697214,660888,121579,325003,476065,983962,955492,954332,387666,510728,1009729,396329,457686,138520,55374,678547,978682,191111,370584,377933,129393,204410,276490,337252,732256,81336) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001780s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412149 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412149 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]