SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1032747 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1032747 [ RunTime:0.001694s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539307,60840,399159,481019,622035,986587,158388,414214,461166,165258,1039742,240055,798021,876771,237961,437012,226471,49012,110828,405692,225598,1030635,785489,567593,316144,671138,315376,665211,478087,18871,928254,252068,310161,209338,369576,208400,627222,847587,97102,466923,259018,879648,946106,149312,711164,338918,832229,641143,99212,208071,449580,500114,970917,356287,824903,219128,437725,491348,116190,608724) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1032747 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000313s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1032747 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000581s ]