SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003049s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547628 LIMIT 1 [ RunTime:0.000481s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547628 [ RunTime:0.002761s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55930,979700,935186,390534,497535,879887,1030352,738377,606866,413742,1027870,933820,449892,967724,88259,1041809,634781,672553,733201,961112,701243,581125,727161,776709,2314,627857,521335,282517,427005,32819,888867,196271,192969,320880,736473,344039,958449,227417,234639,791123,939346,348424,140628,126646,1030553,370384,647732,546650,580931,718471,680416,857672,960020,252127,345506,325323,112203,556160,800184,604745) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004866s ]