SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001255s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 550443 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 550443 [ RunTime:0.003452s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (513102,894346,789470,518162,1041377,406329,539920,875851,234408,993798,52280,382186,593589,891637,402308,316776,503875,980187,615146,537003,840729,505711,46843,823999,971053,816261,284881,944652,611912,854178,174099,676234,530633,1029140,907588,728447,46004,705373,588833,321062,348015,739151,13559,568702,734732,28304,544406,256364,456000,885233,275624,697513,368378,950632,322361,451487,380121,829956,936480,527805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 550443 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 550443 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000807s ]