SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014377 LIMIT 1 [ RunTime:0.000604s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014377 [ RunTime:0.004479s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (334162,770106,536235,374771,119619,178317,79633,335214,206682,458062,895765,561923,940190,992737,163570,850646,132568,164219,452940,622579,790486,343857,716044,76923,708764,897621,162156,305623,57917,731192,776122,86730,419611,37497,479262,852308,1032213,207054,968227,83517,513669,1002804,20581,100107,1030849,501777,1006941,609009,1040291,705989,636096,783886,521428,804860,660628,284041,278855,286587,234501,145514) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014377 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014377 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004203s ]