SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402545 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402545 [ RunTime:0.002259s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365796,205585,864135,875627,174499,191731,503523,54302,101216,368514,839756,819819,781997,767652,984654,762125,183209,905678,359982,707107,605467,472237,910402,665756,773933,783773,672001,420712,200649,665687,251371,305657,881488,1042886,198968,325483,192656,369914,903973,962722,164993,1033900,785143,24401,354555,610749,1030294,967124,377797,7878,497969,926918,127707,496298,986199,806027,1037146,705326,387688,356357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000977s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000424s ]