SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 451818 LIMIT 1 [ RunTime:0.000389s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 451818 [ RunTime:0.001639s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (261287,58428,627668,792797,665711,607868,451463,992787,931385,831040,590630,966055,951358,308215,689275,477513,274644,629824,426682,77461,369489,298010,392895,208481,55017,1029644,765688,846756,104948,27772,610300,539204,424184,377424,243925,885196,47301,571890,378029,966720,88585,740031,1411,439356,329181,734858,477527,721443,788678,768885,481307,892265,119723,864734,625615,920578,677884,18404,543877,514716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 451818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 451818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000604s ]