SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401086 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401086 [ RunTime:0.001704s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (704225,794067,201908,985431,6136,694085,256574,563246,901438,624247,2346,678729,520890,216100,421139,241403,550988,1048533,955965,896943,116141,111104,202212,324771,410450,616942,453148,478728,35732,843962,460700,732660,260017,160923,1013095,189142,642685,467604,514417,13482,475086,357405,894581,526684,427756,172664,110550,463832,680062,521032,133555,275487,936903,496100,870686,305416,623672,598696,6559,89833) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401086 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401086 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]