SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005343 LIMIT 1 [ RunTime:0.003455s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005343 [ RunTime:0.006051s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (325272,424880,488357,347477,791012,826470,1032506,1006838,786305,1032639,908375,787894,339994,639589,436645,1001338,43625,263853,851708,62136,348015,667592,965882,756730,640283,261646,830822,988207,1038664,526529,451480,150417,393959,377816,1023905,631073,431188,161245,338550,339243,538242,263964,1046300,124304,609659,797340,366911,811606,169860,598236,915343,698320,147852,697112,333185,28329,399949,503813,1047121,444252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004135s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]