SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203177 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203177 [ RunTime:0.001632s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (477827,329282,188677,953450,505919,21412,216268,664758,212794,1016157,245795,1045422,281657,419023,661383,307969,937055,150650,253379,104803,87313,461563,808215,625274,704137,395343,619848,432226,186218,760518,67339,482588,390803,671434,402803,282717,272407,1022154,462821,667317,126095,750262,266238,680672,793142,160851,908229,756466,459704,898800,935468,556346,187900,993873,433091,182619,322717,931564,366015,380745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203177 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000336s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203177 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]