SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 399815 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 399815 [ RunTime:0.001956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (951003,261033,788708,354729,633427,951913,1014048,157230,360513,932396,369305,445354,1015390,133259,605029,389205,190699,723591,1023026,541463,834692,702324,93424,428381,987236,556208,72890,372741,688564,412327,9010,50948,928502,670254,834952,1040088,485170,840828,505949,493898,1039530,957507,811440,1044619,877948,110200,806649,121965,700335,54634,1047132,687412,1016529,558186,272030,735902,322661,595782,926050,778743) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 399815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 399815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]