SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 671493 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 671493 [ RunTime:0.001646s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (348455,279277,825926,609676,876040,749219,1043053,520217,1004289,887468,788370,857441,726644,656028,576113,1035735,684789,456077,997357,429124,792950,297687,335585,621206,414449,758004,229847,655826,1023637,591143,243811,731318,992677,556674,775653,700516,253025,439851,302499,504917,1041576,810852,326304,369583,553567,401468,921361,755812,771653,513400,91859,90122,564244,914396,860151,43576,67854,517164,885485,860490) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 671493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000527s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 671493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000853s ]