SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 524071 LIMIT 1 [ RunTime:0.001232s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 524071 [ RunTime:0.003318s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (786076,28875,387428,390134,442505,1021965,747731,72408,828699,350211,712430,219915,117242,356307,393659,605429,860562,58003,1018942,166034,405916,18023,186854,458108,857507,453285,549611,325442,474267,736846,1013440,1023337,310420,63449,197962,987079,464917,365471,996455,959258,482167,896631,703677,857473,33891,760966,542411,240022,847515,675510,197398,686077,746377,750139,119497,585668,341662,680096,118706,343796) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 524071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 524071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]