SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405810 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405810 [ RunTime:0.002751s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (36822,455,102395,811379,911317,675972,311485,913546,359127,185227,722487,497122,754377,518928,788086,647288,566372,540639,69469,102229,127430,929172,299302,185457,262908,555131,671499,25189,569416,55486,547613,834195,928990,276452,946226,621148,921074,58271,296130,676766,722041,1017868,237955,623692,937138,150998,45468,267335,196923,809980,39198,1016591,50434,982310,77158,333394,317797,66932,249779,860451) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003909s ]