SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287251 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287251 [ RunTime:0.002830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (982948,230754,1017797,210740,660964,274207,845980,999122,518213,423670,536809,871494,771984,783674,493013,1038722,218944,13437,298074,540251,410378,347638,62193,371029,677111,634102,412473,796112,709161,565813,116327,580928,793416,293901,148109,545943,891787,483074,134152,734791,666685,252464,958266,302105,277878,875041,477583,671194,291447,40205,177212,91786,742235,916822,971060,556940,630500,1018342,964012,871504) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287251 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287251 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]