SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 8011 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 8011 [ RunTime:0.001487s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463551,427293,236343,667829,541085,901693,778440,49590,48081,649516,1007838,150786,717953,634015,886309,858522,212570,1045197,1039484,951047,597236,797542,536700,376785,698044,805280,469454,48878,558858,650112,94160,343025,482444,596143,910573,959469,615840,114552,940337,158165,672123,872320,76078,367559,177987,204504,496936,157869,538773,51970,478383,936220,337891,25121,900459,577418,842058,710977,574625,565456) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000952s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 8011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 8011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]