SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409804 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409804 [ RunTime:0.001588s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (240986,881737,880230,65193,477753,473020,276362,889881,276408,193110,747950,819095,483067,886935,836618,341176,198158,165188,525847,403608,886032,322893,1008471,936018,88845,886174,287539,1034246,616129,443228,857958,113550,342767,854484,897971,136496,162588,387992,696061,867720,351197,895532,832981,884439,474922,689914,844187,849896,870807,295687,817448,596858,936092,1024473,418423,188114,15530,726204,87485,336005) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001497s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]