SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53394 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53394 [ RunTime:0.003857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410261,557139,917341,136451,781475,734547,577861,587890,528404,84577,407025,374414,337419,564922,666771,1035197,741117,719478,288142,289453,833261,337328,849526,191843,358180,554066,98642,850691,831915,834057,276764,982526,818491,654681,79530,944997,205499,552052,811437,856327,553697,782390,281549,676044,66750,270257,776002,732490,213784,1044278,858277,658728,227110,495400,841185,543760,902179,926001,673121,388923) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001206s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002271s ]