SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1029111 LIMIT 1 [ RunTime:0.001797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1029111 [ RunTime:0.001854s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (474319,134810,702177,919717,837273,611558,475792,145064,459456,355034,913728,817680,977058,500023,859802,495281,717550,953889,953762,271790,856705,869034,821377,772054,270874,323071,866971,762339,377262,747757,936083,764324,405331,294986,846371,913321,158497,445601,981679,764610,833712,31088,923225,701355,1004010,769106,154025,304791,38914,312109,636886,590172,43065,926130,558072,397882,769906,29611,638625,744386) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1029111 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1029111 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]