SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 806187 LIMIT 1 [ RunTime:0.002635s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 806187 [ RunTime:0.003194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (694256,101030,445145,524875,304342,253283,421472,630393,234594,154397,469103,352322,694854,797657,392387,487097,465010,158649,992672,659971,336358,1047891,908212,476398,299966,415705,151403,176481,639871,780908,300740,12983,1013609,195211,596346,505983,755054,875630,329690,788424,949051,1008954,256261,403435,174053,284947,673375,852896,861239,108366,957911,185301,984950,179184,255150,714694,118368,741324,254113,340522) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003416s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 806187 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 806187 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]