SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 477584 LIMIT 1 [ RunTime:0.000460s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 477584 [ RunTime:0.002558s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205266,20100,998580,37953,167512,681287,425369,40598,215334,497297,342230,625225,402219,840247,928870,97779,570219,547909,346130,1028071,19630,680262,663455,949015,539802,865801,314120,806315,230747,190209,195408,498539,878098,1031001,137963,843723,369891,121002,686966,1029142,844003,324703,837765,437590,839782,812977,47489,521198,753260,150135,840137,3681,319609,113250,417792,48650,302583,503572,722945,602041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 477584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000411s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 477584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000695s ]