SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002833s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 320048 LIMIT 1 [ RunTime:0.003806s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 320048 [ RunTime:0.002203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (213970,749999,349184,741213,941154,322245,987726,219265,416461,175350,528081,859706,245552,860560,738313,598602,370909,944963,661960,513979,878592,242847,732025,837052,870593,322832,815626,970928,929544,476772,147989,393025,210934,910504,669942,946242,412467,340231,365046,670402,822534,598385,293446,840579,1001008,1022508,111870,661367,623551,744398,679104,541021,899765,579506,142117,46822,972747,894263,30908,763113) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 320048 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000638s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 320048 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001755s ]