SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 368706 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 368706 [ RunTime:0.002260s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634080,686640,411260,1035697,559001,301297,795572,38301,990910,953331,861618,717615,621230,931170,95301,759620,374999,470574,60134,176552,75814,335216,531488,101594,916560,54918,36600,350900,690647,28919,457769,1003413,741607,196598,405761,361987,45151,80414,805570,891697,502954,105996,521553,175081,550744,701140,626815,593349,788873,922348,590545,652868,25282,611956,770544,257383,47485,390243,1003689,182566) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000950s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 368706 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 368706 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]