SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001424s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404399 LIMIT 1 [ RunTime:0.000735s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404399 [ RunTime:0.001734s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298141,85746,876050,186112,283854,1012075,494673,855909,196733,45681,265195,700731,134587,824065,421713,686040,619823,666959,245786,799693,446108,984669,1000874,12382,331002,375336,1039422,987877,1011056,362372,911204,870297,577551,636571,870082,37617,976141,993996,589713,546814,256703,335853,746096,653950,429736,13847,348997,386050,788805,113939,364278,621296,760315,492669,450894,911308,401058,1025565,382596,993978) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001759s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404399 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404399 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000373s ]