SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1041336 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1041336 [ RunTime:0.001775s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (958008,364636,750950,322408,584701,419897,109269,1383,701480,125071,148989,662023,953177,325405,996134,65563,246310,136704,176679,523239,879459,398318,970290,580801,895233,180700,1033373,354334,139076,145453,49056,201531,1013641,494751,638193,270729,618919,292232,445212,809615,540640,1040943,616814,659543,782612,982787,251229,981364,318002,575981,961488,616177,572494,97310,1027513,346271,480235,145882,545792,678135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001004s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1041336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1041336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]