SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004718s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396401 LIMIT 1 [ RunTime:0.000496s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396401 [ RunTime:0.002033s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822982,245954,460348,1017460,125962,975229,171685,439824,726394,23728,782793,619781,505641,83709,755050,267568,1031553,527433,658932,641572,347258,883042,102644,728554,885401,38366,351358,937854,839475,405408,732910,1015199,55405,995393,507723,239842,842058,141098,580642,1006628,720882,299629,424830,172412,338321,949643,835867,812077,991175,360185,882427,271073,744178,829087,368029,4976,695941,654557,535074,372931) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396401 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000565s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396401 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000741s ]