SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001299s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 341027 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 341027 [ RunTime:0.002180s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400922,552076,742804,156216,359195,994873,281418,313020,227895,746447,299962,636532,947033,82257,54254,235080,267446,188842,1040769,836477,660012,753665,137310,217285,860595,995518,966651,240272,117047,279839,404095,325095,33167,1036317,242535,806671,732866,723886,207212,790022,917919,339861,232475,709041,593791,1035074,129360,868804,793312,631554,1031849,476625,143835,553681,270859,368951,28116,3430,1002341,589624) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004687s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 341027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 341027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003339s ]