SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023441 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023441 [ RunTime:0.001481s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017328,389675,676154,485684,677866,971184,649471,762754,333220,632584,63640,594052,1037506,728973,460210,64290,256079,703468,432426,715586,264651,383221,835337,641367,168009,79254,899566,346033,169555,917173,723890,784117,176514,1047616,405257,264041,283598,894823,165537,787085,470048,378318,330239,382918,402780,575212,249925,246301,224464,578028,1047191,330488,711881,742998,564558,8138,339040,31046,1035894,441120) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001601s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003873s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]