SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.005458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509156 LIMIT 1 [ RunTime:0.004850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509156 [ RunTime:0.008869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771375,386566,877041,988384,121527,803150,657178,1001979,315988,164559,707661,184584,1036518,142706,601167,132063,178264,239108,886199,544609,531068,943195,64829,367807,428017,274714,101849,945889,999158,668968,652090,388679,993014,841239,703486,990024,189757,103673,599709,408427,297552,243917,440575,130063,74515,13810,243232,704074,169763,919908,707685,1000255,631749,767690,1012794,998933,238153,144487,116131,490379) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001100s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509156 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004951s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509156 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]