SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001202s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102535 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102535 [ RunTime:0.001589s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (266025,252208,250663,504420,798221,306519,270755,841473,599377,207985,587585,889410,384201,375535,305685,968738,668435,252247,681050,455850,551261,754521,48434,829436,864197,525963,125869,683259,696853,577536,21354,237186,374915,914562,799040,211020,945976,467712,589162,448046,199834,166815,808117,974201,419471,204800,555231,46758,193377,420075,211204,748372,947623,68740,932763,594700,1018866,237354,586999,466393) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001548s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102535 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102535 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000579s ]