SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001133s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139583 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139583 [ RunTime:0.001772s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (554758,385807,853071,898041,374294,793925,895181,822842,205854,845579,696473,950886,143557,296858,960768,139504,956758,347981,536432,117820,342151,522418,165,491302,543858,929428,1035201,852842,521134,75729,177377,393046,481411,555259,196674,205651,50803,22505,890148,798733,46933,680475,423630,783849,284846,212640,478491,904066,683181,258603,907910,589906,96113,78313,177964,817311,435666,195212,82280,67200) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]