SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549061 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549061 [ RunTime:0.002423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (270694,108246,695106,794583,964180,711767,20883,1004395,385930,868574,952315,10274,172003,561601,720951,77690,1046518,565025,560443,1000123,144896,95862,1008535,1014304,963283,545996,921541,541685,484768,243215,450694,767363,5818,567030,995020,4929,261481,328335,414115,1019892,444044,694313,400209,914842,935944,181310,80140,302917,226809,881693,764543,299211,474901,642794,1043665,429953,177827,1023447,113192,505999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549061 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549061 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]