SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 540810 LIMIT 1 [ RunTime:0.001520s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 540810 [ RunTime:0.008080s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629744,952001,925334,579486,847386,673930,688066,502558,923228,1014680,1008011,582122,983436,755986,360110,821824,197800,93874,794514,73714,379210,167220,919002,745535,743110,357680,357741,834247,900427,509514,15007,612470,507326,337194,1028954,676672,722820,886921,509321,1009237,556435,856587,354741,687123,595586,257766,235320,715966,926283,358176,522140,629544,614511,216327,1006145,354025,938303,962075,233492,796134) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007823s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 540810 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 540810 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000466s ]