SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012609 LIMIT 1 [ RunTime:0.000476s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012609 [ RunTime:0.005945s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226595,297764,798242,554307,311975,254773,79366,881991,1000223,252884,801398,260613,72272,580345,641055,207521,544288,811704,548566,1030527,513728,153054,469401,421844,518516,128501,701694,686395,308254,454989,767479,736048,841421,743458,181298,458642,602301,872232,923115,180428,290599,748652,382988,96824,159069,84272,317440,304485,178000,871345,434178,215555,510284,502919,802691,954054,88200,317436,71594,137898) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012609 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000509s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012609 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]