SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 122613 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 122613 [ RunTime:0.001477s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (85607,896634,923977,226951,197375,326060,593896,280630,464721,67100,277286,426345,1014251,208016,465264,17354,449606,260963,655610,444016,383051,306269,438015,456302,349284,331186,986340,169920,591401,516369,511708,856746,741939,470617,885485,882078,40592,972246,861126,35636,129251,82479,355300,463438,32672,804841,4794,855979,460107,346089,907502,412126,282589,17857,199173,223028,998518,1040316,749398,933967) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004909s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 122613 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 122613 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]