SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 517091 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 517091 [ RunTime:0.001747s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (182020,433060,496162,68836,189191,453832,478958,1007688,902472,765319,140912,275065,821077,1029210,619947,743219,415042,942471,535913,480444,544057,818995,680151,261391,33905,1033181,734078,128679,722862,269562,693688,156523,221489,436788,14890,529566,216314,247144,821429,1023240,883362,924465,754949,196920,276186,689736,1012081,987763,761902,44252,1020061,175787,1019464,992178,628474,454362,886963,386603,612646,848229) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 517091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 517091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]