SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 585740 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 585740 [ RunTime:0.002802s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (31378,476542,979011,453800,1010284,546009,230667,319384,587415,310690,720039,85782,73520,373085,754479,161230,82645,371375,291517,996844,143944,1037410,417183,44307,1249,418386,761680,844513,233113,495885,760770,744413,1020440,543139,112090,239583,112670,163601,944350,925150,754332,130847,223638,193982,529469,802932,424503,123527,666359,488664,40001,540232,203897,74612,1023167,919801,977485,510500,396223,907089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 585740 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 585740 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]