SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012250 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012250 [ RunTime:0.002504s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (150691,895821,566510,490243,41774,247645,195752,712622,545378,481349,477065,523253,401229,106772,526081,407268,237200,443597,370799,436970,386949,50317,33889,847719,161955,711684,649892,391967,581309,164350,720118,722306,749862,689861,92239,845442,942210,662769,696703,903923,957840,87180,397205,50105,1025892,834670,751280,568087,735518,554091,921153,856506,844608,382832,909300,289577,1016968,362263,404209,1033127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]