SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541079 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541079 [ RunTime:0.003950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470688,933714,391738,310373,552155,652399,277877,288460,130316,900440,138031,182696,199206,210017,395309,797352,66379,495132,93041,33455,21422,687183,661014,909921,425319,579860,817034,322564,632123,601153,581331,486177,203070,53132,694183,110007,336108,626522,725315,153104,605510,532280,201666,980701,836385,285546,134973,340004,840555,3675,670088,1010777,143132,768460,381865,16426,8854,514310,235350,525484) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541079 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541079 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000468s ]