SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 316724 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 316724 [ RunTime:0.001783s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (492661,271854,224981,204083,115513,701634,165689,439315,962298,12059,356410,805532,711648,1021679,951146,641046,837869,169943,1021793,932256,76878,601141,545532,596681,467772,595880,978852,834618,838263,682917,125865,163038,987877,475497,854293,459876,260438,109158,351681,242179,494332,488814,228273,852476,786862,1043656,98420,24871,934424,615250,495532,597014,709792,892767,1027570,138258,363086,946511,347979,342325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 316724 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 316724 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000556s ]