SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005490 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005490 [ RunTime:0.001524s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (956843,326489,971439,546979,132090,601233,844290,818423,86774,744308,147364,235295,603085,332444,855320,260309,531896,115326,463310,351989,135912,825701,679109,641384,506549,164400,669305,896786,81424,958764,15827,799540,930982,743465,610836,481851,747027,369930,731964,118372,461792,154522,371374,273051,507834,663098,517552,710820,428766,16886,125925,864661,731889,331382,77371,70461,505244,573441,155769,227669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005490 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005490 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]