SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 360601 LIMIT 1 [ RunTime:0.001547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 360601 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (423405,943217,460745,740089,375710,894912,547981,42658,699304,450791,242789,770311,306161,146399,127666,342560,184980,764400,481498,408036,298503,395300,212151,562517,695955,27149,540579,160920,611649,477143,600885,801780,114665,874803,472059,466431,606573,124373,148389,65002,753152,115837,328987,64469,453688,788062,270569,923442,580854,977268,306440,823668,979736,158939,799771,141819,383014,598460,860039,779276) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.038021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 360601 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001099s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 360601 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002462s ]