SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483545 LIMIT 1 [ RunTime:0.000456s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483545 [ RunTime:0.001986s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820824,247591,847844,7512,508565,680690,1011004,1031401,730491,465522,887953,1011117,404787,568443,797220,541076,10852,914976,308831,683380,781760,321533,266346,968840,700126,427258,969051,675907,105420,156074,699229,450650,272475,29552,718227,562967,599782,994639,329743,981498,346817,794223,758374,448438,859486,790466,639290,726478,31216,675302,563013,491895,1039050,1030868,933204,563015,677187,426116,931112,807032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483545 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483545 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000636s ]