SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548580 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548580 [ RunTime:0.003222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (396262,964693,751601,820922,586089,886841,567810,585659,110930,634739,18719,557324,149274,720072,841473,500518,466007,441972,979748,900238,778142,500463,757118,408046,116169,467860,818639,778885,643989,758223,657013,781535,795812,555186,379373,497830,720017,482297,183056,113321,413178,986083,352554,553082,252015,188147,163912,666154,404507,117220,777062,1034079,97977,87711,385998,822538,425345,1019927,765553,795912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001323s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000421s ]