SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001157s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041027 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041027 [ RunTime:0.004246s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124867,914278,447544,212844,686878,1014016,271497,12591,287829,559810,248029,346040,587252,744080,909480,136473,700494,526835,450909,777303,373199,774600,34493,351641,750940,992955,681363,89083,398312,529961,24005,236056,148985,699193,787101,1027755,142170,933002,446165,364686,474293,743701,225017,269540,165245,127046,432033,645529,264390,670163,315054,53428,296835,898076,344431,336562,893985,770300,626397,294271) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041027 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041027 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]