SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001370s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031501 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031501 [ RunTime:0.002726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (693348,949569,796624,207042,1027923,186600,485798,386155,356169,975144,2108,640909,884974,930330,895568,222242,75284,584858,352665,754354,66379,45706,981791,1036182,971192,377770,771864,825335,457893,448671,270343,555021,30359,638568,288171,558672,716057,970624,303731,854636,652305,594741,982238,366374,226775,125521,824109,585260,434664,624322,674490,771467,427056,851362,358595,25930,25679,660527,935106,424774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001088s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000959s ]